Bentley OpenUtilities CONNECT Edition Help

To Purge and Execute Failed Transactions

Whenever you get failed transactions in the master error queue (Mobileadmin.C$EQ), you can modify the error queue data or that of the server, then attempt to re-apply the transaction via the ExecuteTransaction batch file provided by Bentley.
Parent topic: Database Replication Installation

To Execute Failed Transactions

  1. At the command prompt, run the EXECUTETRANSACTION.BAT utility, in ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
  2. Cmd:\> ExecuteTransaction <Master database host name> <Master Orace SID> <PublicationName> <CHDATA pwd> <Mobileadmin pwd>

    Where:

    • <Master database host name> = Host name of the Master Oracle database.
    • <Master Orace SID> = Oracle SID of the Master database.
    • <PublicationName> = A name for the Workflow Manager Replication Publication.
      Note: This name must be only two characters.
    • <CHDATA pwd> = Password for CHDATA User on the Master database
    • <Mobileadmin pwd> = Password for the MobileAdmin user on the Master database.
    For Example: Cmd:\> EXECUTETRANSACTION MACHINE1 REPTEST WM CHADMIN CHADMIN

To Purge Failed Transactions

The purgetransaction batch file provided by Bentley, purges all transactions from the Mobile Server error queue.

  1. At the command prompt, run the PURGETRANSACTION.BAT utility, in ..\Program Files\Bentley\UtilitiesDesigner\, with the following parameters. Use parameters in the order specified and use a space to separate each value.
  2. Cmd:\> PurgeTransaction <Master database host name> <Master Orace SID> <PublicationName> <CHDATA pwd> <Mobileadmin pwd>

    Where:

    • <Master database host name> = Host name of the Master Oracle database.
    • <Master Orace SID> = Oracle SID of the Master database.
    • <PublicationName> = A name for the Workflow Manager Replication Publication.
      Note: This name must be only two characters.
    • <CHDATA pwd> = Password for CHDATA User on the Master database
    • <Mobileadmin pwd> = Password for the MobileAdmin user on the Master database.
    For Example: Cmd:\> PURGETRANSACTION MACHINE1 REPTEST WM CHADMIN CHADMIN